package com.css.zfzx.sjcj.modules.hddcVolcanicSamplePoint.repository;

import com.css.zfzx.sjcj.modules.hddcA1InvRgnHasMaterialTable.repository.entity.HddcA1InvrgnhasmaterialtableEntity;
import com.css.zfzx.sjcj.modules.hddcVolcanicSamplePoint.repository.entity.HddcVolcanicsamplepointEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

/**
 * @author zhangcong
 * @date 2020-11-27
 */
public interface HddcVolcanicsamplepointRepository extends JpaRepository<HddcVolcanicsamplepointEntity, String> {
    @Query(nativeQuery = true,value = "select v.* from hddc_volcanicsamplepoint v where v.id=?1 and v.is_valid=1")
    HddcVolcanicsamplepointEntity findbyId(String samplepointid);

    HddcVolcanicsamplepointEntity findByUuidAndIsValid(String id, String isValid);
}
